{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "import zmq"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>price</th>\n",
       "      <th>last_close</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>vol</th>\n",
       "      <th>cur_vol</th>\n",
       "      <th>amount</th>\n",
       "      <th>s_vol</th>\n",
       "      <th>...</th>\n",
       "      <th>bid_vol3</th>\n",
       "      <th>ask_vol3</th>\n",
       "      <th>bid4</th>\n",
       "      <th>ask4</th>\n",
       "      <th>bid_vol4</th>\n",
       "      <th>ask_vol4</th>\n",
       "      <th>bid5</th>\n",
       "      <th>ask5</th>\n",
       "      <th>bid_vol5</th>\n",
       "      <th>ask_vol5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110030</td>\n",
       "      <td>1029.1</td>\n",
       "      <td>1029.0</td>\n",
       "      <td>1029.0</td>\n",
       "      <td>1029.2</td>\n",
       "      <td>1028.5</td>\n",
       "      <td>10034</td>\n",
       "      <td>97</td>\n",
       "      <td>10324788.0</td>\n",
       "      <td>5416</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>205</td>\n",
       "      <td>1027.8</td>\n",
       "      <td>1029.8</td>\n",
       "      <td>3</td>\n",
       "      <td>200</td>\n",
       "      <td>1027.7</td>\n",
       "      <td>1029.9</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>113008</td>\n",
       "      <td>1018.6</td>\n",
       "      <td>1018.8</td>\n",
       "      <td>1018.7</td>\n",
       "      <td>1018.8</td>\n",
       "      <td>1018.3</td>\n",
       "      <td>2797</td>\n",
       "      <td>100</td>\n",
       "      <td>2849114.0</td>\n",
       "      <td>1416</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1018.3</td>\n",
       "      <td>1019.1</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>1018.2</td>\n",
       "      <td>1019.2</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     code   price  last_close    open    high     low    vol  cur_vol  \\\n",
       "0  110030  1029.1      1029.0  1029.0  1029.2  1028.5  10034       97   \n",
       "0  113008  1018.6      1018.8  1018.7  1018.8  1018.3   2797      100   \n",
       "\n",
       "       amount  s_vol    ...     bid_vol3  ask_vol3    bid4    ask4  bid_vol4  \\\n",
       "0  10324788.0   5416    ...           11       205  1027.8  1029.8         3   \n",
       "0   2849114.0   1416    ...            2         2  1018.3  1019.1       201   \n",
       "\n",
       "   ask_vol4    bid5    ask5  bid_vol5  ask_vol5  \n",
       "0       200  1027.7  1029.9         5        10  \n",
       "0         2  1018.2  1019.2        31         1  \n",
       "\n",
       "[2 rows x 31 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cons = ts.get_apis()\n",
    "bond_realtime_price = ts.quotes([\"110030\",\"113008\"],conn=cons)\n",
    "bond_realtime_price\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "context   = zmq.Context()\n",
    "publisher = context.socket(zmq.PUB)\n",
    "publisher.bind(\"tcp://*:5563\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['code', 'price', 'last_close', 'open', 'high', 'low', 'vol', 'cur_vol',\n",
       "       'amount', 's_vol', 'b_vol', 'bid1', 'ask1', 'bid_vol1', 'ask_vol1',\n",
       "       'bid2', 'ask2', 'bid_vol2', 'ask_vol2', 'bid3', 'ask3', 'bid_vol3',\n",
       "       'ask_vol3', 'bid4', 'ask4', 'bid_vol4', 'ask_vol4', 'bid5', 'ask5',\n",
       "       'bid_vol5', 'ask_vol5'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_realtime_price.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sendmsg = [\"code\",\"110030\",\"price\",\"1029.0\",\"last_close\",\"1028.6\"]\n",
    "publisher.send_multipart(sendmsg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "subscriber = context.socket(zmq.SUB)   \n",
    "subscriber.connect(\"tcp://localhost:5563\")   \n",
    "subscriber.setsockopt_string(zmq.SUBSCRIBE,\"\")\n",
    "\n",
    "while True:   \n",
    "    revmsg = subscriber.recv_multipart()\n",
    "    print(revmsg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>col1</th>\n",
       "      <th>col2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>r1</th>\n",
       "      <td>a</td>\n",
       "      <td>b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>r2</th>\n",
       "      <td>c</td>\n",
       "      <td>d</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   col1 col2\n",
       "r1    a    b\n",
       "r2    c    d"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame([['a','b'],['c','d']],index=['r1','r2'],columns=['col1','col2'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'[[\"110030\",1029.1,1029.0,1029.0,1029.2,1028.5,10034,97,10324788.0,5416,4618,1028.5,1029.2,148,1302,1028.1,1029.4,1,20,1028.0,1029.5,11,205,1027.8,1029.8,3,200,1027.7,1029.9,5,10],[\"113008\",1018.6,1018.8,1018.7,1018.8,1018.3,2797,100,2849114.0,1416,1381,1018.6,1018.8,38,1047,1018.5,1018.9,1307,119,1018.4,1019.0,2,2,1018.3,1019.1,201,2,1018.2,1019.2,31,1]]'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_realtime_price.to_json(orient='values')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(bond_realtime_price.to_json(orient='values'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>open</th>\n",
       "      <th>pre_close</th>\n",
       "      <th>price</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>bid</th>\n",
       "      <th>ask</th>\n",
       "      <th>volume</th>\n",
       "      <th>amount</th>\n",
       "      <th>...</th>\n",
       "      <th>a2_p</th>\n",
       "      <th>a3_v</th>\n",
       "      <th>a3_p</th>\n",
       "      <th>a4_v</th>\n",
       "      <th>a4_p</th>\n",
       "      <th>a5_v</th>\n",
       "      <th>a5_p</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>中国平安</td>\n",
       "      <td>63.500</td>\n",
       "      <td>63.010</td>\n",
       "      <td>63.250</td>\n",
       "      <td>64.050</td>\n",
       "      <td>63.020</td>\n",
       "      <td>63.240</td>\n",
       "      <td>63.250</td>\n",
       "      <td>44440570</td>\n",
       "      <td>2827908734.000</td>\n",
       "      <td>...</td>\n",
       "      <td>63.260</td>\n",
       "      <td>786</td>\n",
       "      <td>63.270</td>\n",
       "      <td>41</td>\n",
       "      <td>63.280</td>\n",
       "      <td>256</td>\n",
       "      <td>63.290</td>\n",
       "      <td>2018-08-30</td>\n",
       "      <td>14:53:16</td>\n",
       "      <td>601318</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   name    open pre_close   price    high     low     bid     ask    volume  \\\n",
       "0  中国平安  63.500    63.010  63.250  64.050  63.020  63.240  63.250  44440570   \n",
       "\n",
       "           amount   ...      a2_p a3_v    a3_p a4_v    a4_p a5_v    a5_p  \\\n",
       "0  2827908734.000   ...    63.260  786  63.270   41  63.280  256  63.290   \n",
       "\n",
       "         date      time    code  \n",
       "0  2018-08-30  14:53:16  601318  \n",
       "\n",
       "[1 rows x 33 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_realtime_price = ts.get_realtime_quotes(\"601318\")\n",
    "stock_realtime_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['name', 'open', 'pre_close', 'price', 'high', 'low', 'bid', 'ask',\n",
       "       'volume', 'amount', 'b1_v', 'b1_p', 'b2_v', 'b2_p', 'b3_v', 'b3_p',\n",
       "       'b4_v', 'b4_p', 'b5_v', 'b5_p', 'a1_v', 'a1_p', 'a2_v', 'a2_p', 'a3_v',\n",
       "       'a3_p', 'a4_v', 'a4_p', 'a5_v', 'a5_p', 'date', 'time', 'code'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_realtime_price.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "kezhuanzhai=ts.new_cbonds()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "kezhuanzhai.to_csv(\"C:\\\\quanttime\\\\src\\\\convertbond\\\\3.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bcode</th>\n",
       "      <th>bname</th>\n",
       "      <th>scode</th>\n",
       "      <th>sname</th>\n",
       "      <th>xcode</th>\n",
       "      <th>amount</th>\n",
       "      <th>marketprice</th>\n",
       "      <th>convprice</th>\n",
       "      <th>firstdayprice</th>\n",
       "      <th>ipo_date</th>\n",
       "      <th>issue_date</th>\n",
       "      <th>ballot</th>\n",
       "      <th>return</th>\n",
       "      <th>perreturn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>128045</td>\n",
       "      <td>机电转债</td>\n",
       "      <td>002013</td>\n",
       "      <td>中航机电</td>\n",
       "      <td>072013</td>\n",
       "      <td>21.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>128044</td>\n",
       "      <td>岭南转债</td>\n",
       "      <td>002717</td>\n",
       "      <td>岭南股份</td>\n",
       "      <td>072717</td>\n",
       "      <td>6.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>123015</td>\n",
       "      <td>蓝盾转债</td>\n",
       "      <td>300297</td>\n",
       "      <td>蓝盾股份</td>\n",
       "      <td>370297</td>\n",
       "      <td>5.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.27%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>113517</td>\n",
       "      <td>曙光转债</td>\n",
       "      <td>603019</td>\n",
       "      <td>中科曙光</td>\n",
       "      <td>754019</td>\n",
       "      <td>11.20</td>\n",
       "      <td>108.50</td>\n",
       "      <td>51.28</td>\n",
       "      <td>106.36</td>\n",
       "      <td>2018-08-06</td>\n",
       "      <td>2018-08-23</td>\n",
       "      <td>1.93%</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>128043</td>\n",
       "      <td>东音转债</td>\n",
       "      <td>002793</td>\n",
       "      <td>东音股份</td>\n",
       "      <td>072793</td>\n",
       "      <td>2.81</td>\n",
       "      <td>94.82</td>\n",
       "      <td>13.47</td>\n",
       "      <td>96.32</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>46.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113516</td>\n",
       "      <td>吴银转债</td>\n",
       "      <td>603323</td>\n",
       "      <td>吴江银行</td>\n",
       "      <td>754323</td>\n",
       "      <td>25.00</td>\n",
       "      <td>103.84</td>\n",
       "      <td>6.34</td>\n",
       "      <td>99.20</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>0.51%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>19.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>128042</td>\n",
       "      <td>凯中转债</td>\n",
       "      <td>002823</td>\n",
       "      <td>凯中精密</td>\n",
       "      <td>072823</td>\n",
       "      <td>4.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-30</td>\n",
       "      <td>2018-09-03</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>123014</td>\n",
       "      <td>凯发转债</td>\n",
       "      <td>300407</td>\n",
       "      <td>凯发电气</td>\n",
       "      <td>370407</td>\n",
       "      <td>3.50</td>\n",
       "      <td>93.18</td>\n",
       "      <td>8.15</td>\n",
       "      <td>91.15</td>\n",
       "      <td>2018-07-27</td>\n",
       "      <td>2018-08-21</td>\n",
       "      <td>0.45%</td>\n",
       "      <td>-0.04%</td>\n",
       "      <td>22.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>113515</td>\n",
       "      <td>高能转债</td>\n",
       "      <td>603588</td>\n",
       "      <td>高能环境</td>\n",
       "      <td>754588</td>\n",
       "      <td>8.40</td>\n",
       "      <td>99.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99.34</td>\n",
       "      <td>2018-07-26</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>0.34%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>29.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>123013</td>\n",
       "      <td>横河转债</td>\n",
       "      <td>300539</td>\n",
       "      <td>横河模具</td>\n",
       "      <td>370539</td>\n",
       "      <td>1.40</td>\n",
       "      <td>92.83</td>\n",
       "      <td>9.26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-26</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>0.15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>123012</td>\n",
       "      <td>万顺转债</td>\n",
       "      <td>300057</td>\n",
       "      <td>万顺股份</td>\n",
       "      <td>370057</td>\n",
       "      <td>9.50</td>\n",
       "      <td>91.89</td>\n",
       "      <td>6.47</td>\n",
       "      <td>91.92</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>2018-08-29</td>\n",
       "      <td>1.73%</td>\n",
       "      <td>-0.13%</td>\n",
       "      <td>5.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>113514</td>\n",
       "      <td>威帝转债</td>\n",
       "      <td>603023</td>\n",
       "      <td>威帝股份</td>\n",
       "      <td>754023</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.92</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>123011</td>\n",
       "      <td>德尔转债</td>\n",
       "      <td>300473</td>\n",
       "      <td>德尔股份</td>\n",
       "      <td>370473</td>\n",
       "      <td>5.65</td>\n",
       "      <td>98.30</td>\n",
       "      <td>35.26</td>\n",
       "      <td>96.34</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.33%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>30.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>128041</td>\n",
       "      <td>盛路转债</td>\n",
       "      <td>002446</td>\n",
       "      <td>盛路通信</td>\n",
       "      <td>072446</td>\n",
       "      <td>10.00</td>\n",
       "      <td>100.46</td>\n",
       "      <td>6.88</td>\n",
       "      <td>96.83</td>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.61%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>16.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>110045</td>\n",
       "      <td>海澜转债</td>\n",
       "      <td>600398</td>\n",
       "      <td>海澜之家</td>\n",
       "      <td>704398</td>\n",
       "      <td>30.00</td>\n",
       "      <td>99.20</td>\n",
       "      <td>12.40</td>\n",
       "      <td>100.80</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>113513</td>\n",
       "      <td>安井转债</td>\n",
       "      <td>603345</td>\n",
       "      <td>安井食品</td>\n",
       "      <td>754345</td>\n",
       "      <td>5.00</td>\n",
       "      <td>106.65</td>\n",
       "      <td>35.46</td>\n",
       "      <td>110.43</td>\n",
       "      <td>2018-07-12</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>113512</td>\n",
       "      <td>景旺转债</td>\n",
       "      <td>603228</td>\n",
       "      <td>景旺电子</td>\n",
       "      <td>754228</td>\n",
       "      <td>9.78</td>\n",
       "      <td>118.40</td>\n",
       "      <td>50.01</td>\n",
       "      <td>120.45</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>0.23%</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>123010</td>\n",
       "      <td>博世转债</td>\n",
       "      <td>300422</td>\n",
       "      <td>博世科</td>\n",
       "      <td>370422</td>\n",
       "      <td>4.30</td>\n",
       "      <td>95.00</td>\n",
       "      <td>14.30</td>\n",
       "      <td>97.36</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.36%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>27.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>127007</td>\n",
       "      <td>湖广转债</td>\n",
       "      <td>000665</td>\n",
       "      <td>湖北广电</td>\n",
       "      <td>070665</td>\n",
       "      <td>17.34</td>\n",
       "      <td>93.78</td>\n",
       "      <td>10.16</td>\n",
       "      <td>93.16</td>\n",
       "      <td>2018-06-28</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>1.01%</td>\n",
       "      <td>-0.06%</td>\n",
       "      <td>987.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>110044</td>\n",
       "      <td>广电转债</td>\n",
       "      <td>600831</td>\n",
       "      <td>广电网络</td>\n",
       "      <td>733831</td>\n",
       "      <td>8.00</td>\n",
       "      <td>93.91</td>\n",
       "      <td>6.91</td>\n",
       "      <td>95.80</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>24.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>113511</td>\n",
       "      <td>千禾转债</td>\n",
       "      <td>603027</td>\n",
       "      <td>千禾味业</td>\n",
       "      <td>754027</td>\n",
       "      <td>3.56</td>\n",
       "      <td>93.52</td>\n",
       "      <td>25.86</td>\n",
       "      <td>98.87</td>\n",
       "      <td>2018-06-20</td>\n",
       "      <td>2018-07-10</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>70.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>113510</td>\n",
       "      <td>再升转债</td>\n",
       "      <td>603601</td>\n",
       "      <td>再升科技</td>\n",
       "      <td>754601</td>\n",
       "      <td>1.14</td>\n",
       "      <td>93.69</td>\n",
       "      <td>11.32</td>\n",
       "      <td>95.81</td>\n",
       "      <td>2018-06-19</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>0.06%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>158.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>128040</td>\n",
       "      <td>华通转债</td>\n",
       "      <td>002758</td>\n",
       "      <td>华通医药</td>\n",
       "      <td>072758</td>\n",
       "      <td>2.24</td>\n",
       "      <td>90.60</td>\n",
       "      <td>11.45</td>\n",
       "      <td>96.60</td>\n",
       "      <td>2018-06-14</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>232.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>128039</td>\n",
       "      <td>三力转债</td>\n",
       "      <td>002224</td>\n",
       "      <td>三力士</td>\n",
       "      <td>072224</td>\n",
       "      <td>6.20</td>\n",
       "      <td>98.62</td>\n",
       "      <td>7.38</td>\n",
       "      <td>89.50</td>\n",
       "      <td>2018-06-08</td>\n",
       "      <td>2018-06-29</td>\n",
       "      <td>0.13%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>74.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>113509</td>\n",
       "      <td>新泉转债</td>\n",
       "      <td>603179</td>\n",
       "      <td>新泉股份</td>\n",
       "      <td>754179</td>\n",
       "      <td>4.50</td>\n",
       "      <td>99.14</td>\n",
       "      <td>25.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.03%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>326.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>113508</td>\n",
       "      <td>新凤转债</td>\n",
       "      <td>603225</td>\n",
       "      <td>新凤鸣</td>\n",
       "      <td>754225</td>\n",
       "      <td>21.53</td>\n",
       "      <td>103.31</td>\n",
       "      <td>23.74</td>\n",
       "      <td>99.52</td>\n",
       "      <td>2018-04-26</td>\n",
       "      <td>2018-05-16</td>\n",
       "      <td>0.23%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>42.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>113507</td>\n",
       "      <td>天马转债</td>\n",
       "      <td>603668</td>\n",
       "      <td>天马科技</td>\n",
       "      <td>754668</td>\n",
       "      <td>3.05</td>\n",
       "      <td>91.91</td>\n",
       "      <td>10.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-17</td>\n",
       "      <td>2018-05-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>113506</td>\n",
       "      <td>鼎信转债</td>\n",
       "      <td>603421</td>\n",
       "      <td>鼎信通讯</td>\n",
       "      <td>754421</td>\n",
       "      <td>6.00</td>\n",
       "      <td>95.35</td>\n",
       "      <td>21.65</td>\n",
       "      <td>106.16</td>\n",
       "      <td>2018-04-16</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>0.07%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>138.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>128038</td>\n",
       "      <td>利欧转债</td>\n",
       "      <td>002131</td>\n",
       "      <td>利欧股份</td>\n",
       "      <td>072131</td>\n",
       "      <td>21.98</td>\n",
       "      <td>87.50</td>\n",
       "      <td>2.75</td>\n",
       "      <td>97.80</td>\n",
       "      <td>2018-03-22</td>\n",
       "      <td>2018-04-19</td>\n",
       "      <td>0.27%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>37.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>128037</td>\n",
       "      <td>岩土转债</td>\n",
       "      <td>002542</td>\n",
       "      <td>中化岩土</td>\n",
       "      <td>072542</td>\n",
       "      <td>6.04</td>\n",
       "      <td>86.81</td>\n",
       "      <td>8.03</td>\n",
       "      <td>95.20</td>\n",
       "      <td>2018-03-15</td>\n",
       "      <td>2018-04-25</td>\n",
       "      <td>0.09%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>110.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>127006</td>\n",
       "      <td>敖东转债</td>\n",
       "      <td>000623</td>\n",
       "      <td>吉林敖东</td>\n",
       "      <td>070623</td>\n",
       "      <td>24.13</td>\n",
       "      <td>98.64</td>\n",
       "      <td>20.82</td>\n",
       "      <td>105.39</td>\n",
       "      <td>2018-03-13</td>\n",
       "      <td>2018-05-11</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>80.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>127005</td>\n",
       "      <td>长证转债</td>\n",
       "      <td>000783</td>\n",
       "      <td>长江证券</td>\n",
       "      <td>070783</td>\n",
       "      <td>50.00</td>\n",
       "      <td>96.15</td>\n",
       "      <td>7.45</td>\n",
       "      <td>106.90</td>\n",
       "      <td>2018-03-12</td>\n",
       "      <td>2018-04-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>128036</td>\n",
       "      <td>金农转债</td>\n",
       "      <td>002548</td>\n",
       "      <td>金新农</td>\n",
       "      <td>072548</td>\n",
       "      <td>6.50</td>\n",
       "      <td>88.03</td>\n",
       "      <td>9.62</td>\n",
       "      <td>100.01</td>\n",
       "      <td>2018-03-09</td>\n",
       "      <td>2018-04-02</td>\n",
       "      <td>0.05%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>123009</td>\n",
       "      <td>星源转债</td>\n",
       "      <td>300568</td>\n",
       "      <td>星源材质</td>\n",
       "      <td>370568</td>\n",
       "      <td>4.80</td>\n",
       "      <td>116.90</td>\n",
       "      <td>27.69</td>\n",
       "      <td>119.35</td>\n",
       "      <td>2018-03-07</td>\n",
       "      <td>2018-04-10</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>244.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>113505</td>\n",
       "      <td>杭电转债</td>\n",
       "      <td>603618</td>\n",
       "      <td>杭电股份</td>\n",
       "      <td>754618</td>\n",
       "      <td>7.80</td>\n",
       "      <td>92.89</td>\n",
       "      <td>7.29</td>\n",
       "      <td>100.87</td>\n",
       "      <td>2018-03-06</td>\n",
       "      <td>2018-03-27</td>\n",
       "      <td>0.08%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>118.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>113504</td>\n",
       "      <td>艾华转债</td>\n",
       "      <td>603989</td>\n",
       "      <td>艾华集团</td>\n",
       "      <td>754989</td>\n",
       "      <td>6.91</td>\n",
       "      <td>109.01</td>\n",
       "      <td>36.59</td>\n",
       "      <td>108.55</td>\n",
       "      <td>2018-03-02</td>\n",
       "      <td>2018-03-23</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>457.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>113019</td>\n",
       "      <td>玲珑转债</td>\n",
       "      <td>601966</td>\n",
       "      <td>玲珑轮胎</td>\n",
       "      <td>783966</td>\n",
       "      <td>20.00</td>\n",
       "      <td>103.80</td>\n",
       "      <td>18.84</td>\n",
       "      <td>104.97</td>\n",
       "      <td>2018-03-01</td>\n",
       "      <td>2018-03-22</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>47.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>128035</td>\n",
       "      <td>大族转债</td>\n",
       "      <td>002008</td>\n",
       "      <td>大族激光</td>\n",
       "      <td>072008</td>\n",
       "      <td>23.00</td>\n",
       "      <td>107.97</td>\n",
       "      <td>52.50</td>\n",
       "      <td>116.34</td>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>2018-03-05</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>51.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>132015</td>\n",
       "      <td>18中油EB</td>\n",
       "      <td>601857</td>\n",
       "      <td>中国石油</td>\n",
       "      <td>759000</td>\n",
       "      <td>200.00</td>\n",
       "      <td>98.43</td>\n",
       "      <td>9.38</td>\n",
       "      <td>98.68</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>-0.64%</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>123008</td>\n",
       "      <td>康泰转债</td>\n",
       "      <td>300601</td>\n",
       "      <td>康泰生物</td>\n",
       "      <td>370601</td>\n",
       "      <td>3.56</td>\n",
       "      <td>149.88</td>\n",
       "      <td>31.23</td>\n",
       "      <td>119.98</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>2018-03-19</td>\n",
       "      <td>0.03%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>387.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>110043</td>\n",
       "      <td>无锡转债</td>\n",
       "      <td>600908</td>\n",
       "      <td>无锡银行</td>\n",
       "      <td>733908</td>\n",
       "      <td>30.00</td>\n",
       "      <td>97.95</td>\n",
       "      <td>6.85</td>\n",
       "      <td>97.43</td>\n",
       "      <td>2018-01-30</td>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>0.19%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>53.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>128034</td>\n",
       "      <td>江银转债</td>\n",
       "      <td>002807</td>\n",
       "      <td>江阴银行</td>\n",
       "      <td>072807</td>\n",
       "      <td>20.00</td>\n",
       "      <td>100.96</td>\n",
       "      <td>6.92</td>\n",
       "      <td>97.76</td>\n",
       "      <td>2018-01-26</td>\n",
       "      <td>2018-02-14</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>113018</td>\n",
       "      <td>常熟转债</td>\n",
       "      <td>601128</td>\n",
       "      <td>常熟银行</td>\n",
       "      <td>783128</td>\n",
       "      <td>30.00</td>\n",
       "      <td>107.87</td>\n",
       "      <td>7.61</td>\n",
       "      <td>107.91</td>\n",
       "      <td>2018-01-19</td>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>0.19%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>51.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>123007</td>\n",
       "      <td>道氏转债</td>\n",
       "      <td>300409</td>\n",
       "      <td>道氏技术</td>\n",
       "      <td>370409</td>\n",
       "      <td>4.80</td>\n",
       "      <td>95.70</td>\n",
       "      <td>24.99</td>\n",
       "      <td>118.00</td>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>2018-01-26</td>\n",
       "      <td>0.07%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>139.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>113017</td>\n",
       "      <td>吉视转债</td>\n",
       "      <td>601929</td>\n",
       "      <td>吉视传媒</td>\n",
       "      <td>783929</td>\n",
       "      <td>15.60</td>\n",
       "      <td>90.85</td>\n",
       "      <td>2.98</td>\n",
       "      <td>98.08</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>0.40%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>128033</td>\n",
       "      <td>迪龙转债</td>\n",
       "      <td>002658</td>\n",
       "      <td>雪迪龙</td>\n",
       "      <td>072658</td>\n",
       "      <td>5.20</td>\n",
       "      <td>95.67</td>\n",
       "      <td>13.28</td>\n",
       "      <td>104.00</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>2018-01-29</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>258.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>110042</td>\n",
       "      <td>航电转债</td>\n",
       "      <td>600372</td>\n",
       "      <td>中航电子</td>\n",
       "      <td>733372</td>\n",
       "      <td>24.00</td>\n",
       "      <td>107.00</td>\n",
       "      <td>14.29</td>\n",
       "      <td>101.76</td>\n",
       "      <td>2017-12-25</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>50.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>128032</td>\n",
       "      <td>双环转债</td>\n",
       "      <td>002472</td>\n",
       "      <td>双环传动</td>\n",
       "      <td>072472</td>\n",
       "      <td>10.00</td>\n",
       "      <td>95.60</td>\n",
       "      <td>9.99</td>\n",
       "      <td>104.75</td>\n",
       "      <td>2017-12-25</td>\n",
       "      <td>2018-01-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>110041</td>\n",
       "      <td>蒙电转债</td>\n",
       "      <td>600863</td>\n",
       "      <td>内蒙华电</td>\n",
       "      <td>733863</td>\n",
       "      <td>18.75</td>\n",
       "      <td>98.18</td>\n",
       "      <td>2.95</td>\n",
       "      <td>104.18</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>2018-01-09</td>\n",
       "      <td>0.27%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>37.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>128029</td>\n",
       "      <td>太阳转债</td>\n",
       "      <td>002078</td>\n",
       "      <td>太阳纸业</td>\n",
       "      <td>072078</td>\n",
       "      <td>12.00</td>\n",
       "      <td>118.46</td>\n",
       "      <td>8.85</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>2018-01-16</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     bcode   bname   scode sname   xcode  amount  marketprice  convprice  \\\n",
       "0   128045    机电转债  002013  中航机电  072013   21.00          NaN       7.66   \n",
       "1   128044    岭南转债  002717  岭南股份  072717    6.60          NaN      10.70   \n",
       "2   123015    蓝盾转债  300297  蓝盾股份  370297    5.38          NaN       7.89   \n",
       "3   113517    曙光转债  603019  中科曙光  754019   11.20       108.50      51.28   \n",
       "4   128043    东音转债  002793  东音股份  072793    2.81        94.82      13.47   \n",
       "5   113516    吴银转债  603323  吴江银行  754323   25.00       103.84       6.34   \n",
       "6   128042    凯中转债  002823  凯中精密  072823    4.16          NaN      13.25   \n",
       "7   123014    凯发转债  300407  凯发电气  370407    3.50        93.18       8.15   \n",
       "8   113515    高能转债  603588  高能环境  754588    8.40        99.99        NaN   \n",
       "9   123013    横河转债  300539  横河模具  370539    1.40        92.83       9.26   \n",
       "10  123012    万顺转债  300057  万顺股份  370057    9.50        91.89       6.47   \n",
       "11  113514    威帝转债  603023  威帝股份  754023    2.00          NaN       5.92   \n",
       "12  123011    德尔转债  300473  德尔股份  370473    5.65        98.30      35.26   \n",
       "13  128041    盛路转债  002446  盛路通信  072446   10.00       100.46       6.88   \n",
       "14  110045    海澜转债  600398  海澜之家  704398   30.00        99.20      12.40   \n",
       "15  113513    安井转债  603345  安井食品  754345    5.00       106.65      35.46   \n",
       "16  113512    景旺转债  603228  景旺电子  754228    9.78       118.40      50.01   \n",
       "17  123010    博世转债  300422   博世科  370422    4.30        95.00      14.30   \n",
       "18  127007    湖广转债  000665  湖北广电  070665   17.34        93.78      10.16   \n",
       "19  110044    广电转债  600831  广电网络  733831    8.00        93.91       6.91   \n",
       "20  113511    千禾转债  603027  千禾味业  754027    3.56        93.52      25.86   \n",
       "21  113510    再升转债  603601  再升科技  754601    1.14        93.69      11.32   \n",
       "22  128040    华通转债  002758  华通医药  072758    2.24        90.60      11.45   \n",
       "23  128039    三力转债  002224   三力士  072224    6.20        98.62       7.38   \n",
       "24  113509    新泉转债  603179  新泉股份  754179    4.50        99.14      25.34   \n",
       "25  113508    新凤转债  603225   新凤鸣  754225   21.53       103.31      23.74   \n",
       "26  113507    天马转债  603668  天马科技  754668    3.05        91.91      10.98   \n",
       "27  113506    鼎信转债  603421  鼎信通讯  754421    6.00        95.35      21.65   \n",
       "28  128038    利欧转债  002131  利欧股份  072131   21.98        87.50       2.75   \n",
       "29  128037    岩土转债  002542  中化岩土  072542    6.04        86.81       8.03   \n",
       "30  127006    敖东转债  000623  吉林敖东  070623   24.13        98.64      20.82   \n",
       "31  127005    长证转债  000783  长江证券  070783   50.00        96.15       7.45   \n",
       "32  128036    金农转债  002548   金新农  072548    6.50        88.03       9.62   \n",
       "33  123009    星源转债  300568  星源材质  370568    4.80       116.90      27.69   \n",
       "34  113505    杭电转债  603618  杭电股份  754618    7.80        92.89       7.29   \n",
       "35  113504    艾华转债  603989  艾华集团  754989    6.91       109.01      36.59   \n",
       "36  113019    玲珑转债  601966  玲珑轮胎  783966   20.00       103.80      18.84   \n",
       "37  128035    大族转债  002008  大族激光  072008   23.00       107.97      52.50   \n",
       "38  132015  18中油EB  601857  中国石油  759000  200.00        98.43       9.38   \n",
       "39  123008    康泰转债  300601  康泰生物  370601    3.56       149.88      31.23   \n",
       "40  110043    无锡转债  600908  无锡银行  733908   30.00        97.95       6.85   \n",
       "41  128034    江银转债  002807  江阴银行  072807   20.00       100.96       6.92   \n",
       "42  113018    常熟转债  601128  常熟银行  783128   30.00       107.87       7.61   \n",
       "43  123007    道氏转债  300409  道氏技术  370409    4.80        95.70      24.99   \n",
       "44  113017    吉视转债  601929  吉视传媒  783929   15.60        90.85       2.98   \n",
       "45  128033    迪龙转债  002658   雪迪龙  072658    5.20        95.67      13.28   \n",
       "46  110042    航电转债  600372  中航电子  733372   24.00       107.00      14.29   \n",
       "47  128032    双环转债  002472  双环传动  072472   10.00        95.60       9.99   \n",
       "48  110041    蒙电转债  600863  内蒙华电  733863   18.75        98.18       2.95   \n",
       "49  128029    太阳转债  002078  太阳纸业  072078   12.00       118.46       8.85   \n",
       "\n",
       "    firstdayprice    ipo_date  issue_date  ballot  return  perreturn  \n",
       "0             NaN  2018-08-27         NaN   0.12%     NaN      83.70  \n",
       "1             NaN  2018-08-14         NaN     NaN     NaN        NaN  \n",
       "2             NaN  2018-08-13         NaN   1.27%     NaN       7.86  \n",
       "3          106.36  2018-08-06  2018-08-23   1.93%   0.02%       0.00  \n",
       "4           96.32  2018-08-02  2018-08-27   0.21%  -0.01%      46.91  \n",
       "5           99.20  2018-08-02  2018-08-20   0.51%  -0.01%      19.66  \n",
       "6             NaN  2018-07-30  2018-09-03   0.20%     NaN      50.47  \n",
       "7           91.15  2018-07-27  2018-08-21   0.45%  -0.04%      22.01  \n",
       "8           99.34  2018-07-26  2018-08-27   0.34%  -0.01%      29.71  \n",
       "9             NaN  2018-07-26  2018-08-20   0.15%     NaN      66.77  \n",
       "10          91.92  2018-07-20  2018-08-29   1.73%  -0.13%       5.80  \n",
       "11            NaN  2018-07-20  2018-08-13   0.28%     NaN      35.32  \n",
       "12          96.34  2018-07-18  2018-08-14   0.33%  -0.01%      30.74  \n",
       "13          96.83  2018-07-17  2018-08-14   0.61%  -0.01%      16.43  \n",
       "14         100.80  2018-07-13  2018-07-31     NaN     NaN        NaN  \n",
       "15         110.43  2018-07-12  2018-07-31     NaN     NaN        NaN  \n",
       "16         120.45  2018-07-06  2018-07-24   0.23%   0.04%       4.35  \n",
       "17          97.36  2018-07-05  2018-08-14   0.36%   0.00%      27.72  \n",
       "18          93.16  2018-06-28  2018-08-01   1.01%  -0.06%     987.37  \n",
       "19          95.80  2018-06-27  2018-07-24   0.41%  -0.02%      24.16  \n",
       "20          98.87  2018-06-20  2018-07-10   0.14%   0.00%      70.06  \n",
       "21          95.81  2018-06-19  2018-07-13   0.06%   0.00%     158.60  \n",
       "22          96.60  2018-06-14  2018-07-13   0.04%   0.00%     232.06  \n",
       "23          89.50  2018-06-08  2018-06-29   0.13%  -0.01%      74.95  \n",
       "24            NaN  2018-06-04         NaN   0.03%     NaN     326.41  \n",
       "25          99.52  2018-04-26  2018-05-16   0.23%   0.00%      42.81  \n",
       "26            NaN  2018-04-17  2018-05-07     NaN     NaN        NaN  \n",
       "27         106.16  2018-04-16  2018-05-14   0.07%   0.01%     138.80  \n",
       "28          97.80  2018-03-22  2018-04-19   0.27%   0.00%      37.01  \n",
       "29          95.20  2018-03-15  2018-04-25   0.09%   0.00%     110.95  \n",
       "30         105.39  2018-03-13  2018-05-11   0.12%   0.01%      80.80  \n",
       "31         106.90  2018-03-12  2018-04-11     NaN     NaN        NaN  \n",
       "32         100.01  2018-03-09  2018-04-02   0.05%   0.00%        NaN  \n",
       "33         119.35  2018-03-07  2018-04-10   0.04%   0.01%     244.49  \n",
       "34         100.87  2018-03-06  2018-03-27   0.08%   0.00%     118.57  \n",
       "35         108.55  2018-03-02  2018-03-23   0.02%   0.00%     457.45  \n",
       "36         104.97  2018-03-01  2018-03-22   0.21%   0.01%      47.21  \n",
       "37         116.34  2018-02-06  2018-03-05   0.20%   0.02%      51.07  \n",
       "38          98.68  2018-02-01  2018-02-28  30.00%  -0.64%       3.05  \n",
       "39         119.98  2018-02-01  2018-03-19   0.03%   0.01%     387.05  \n",
       "40          97.43  2018-01-30  2018-03-14   0.19%   0.00%      53.15  \n",
       "41          97.76  2018-01-26  2018-02-14   0.14%   0.00%      72.00  \n",
       "42         107.91  2018-01-19  2018-02-06   0.19%   0.01%      51.99  \n",
       "43         118.00  2017-12-28  2018-01-26   0.07%   0.01%     139.22  \n",
       "44          98.08  2017-12-27  2018-01-15   0.40%   0.01%       0.10  \n",
       "45         104.00  2017-12-27  2018-01-29   0.04%   0.00%     258.40  \n",
       "46         101.76  2017-12-25  2018-01-15   0.20%   0.01%      50.80  \n",
       "47         104.75  2017-12-25  2018-01-25     NaN     NaN        NaN  \n",
       "48         104.18  2017-12-22  2018-01-09   0.27%   0.01%      37.51  \n",
       "49            NaN  2017-12-22  2018-01-16   0.04%     NaN     232.16  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kezhuanzhai"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "bondbasic=pd.read_csv(\"C:\\\\quanttime\\\\src\\\\convertbond\\\\5.csv\",encoding=\"gbk\")\n",
    "stockinfo=pd.read_csv(\"C:\\\\quanttime\\\\data\\\\basic_info\\\\all_stock_info.csv\",encoding=\"gbk\")\n",
    "testfile = pd.merge(bondbasic,stockinfo,left_on=\"sname\", right_on=\"display_name\")\n",
    "testfile.to_csv(\"C:\\\\quanttime\\\\src\\\\convertbond\\\\kezhuanzhai1.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>bcode</th>\n",
       "      <th>bname</th>\n",
       "      <th>scode</th>\n",
       "      <th>sname</th>\n",
       "      <th>xcode</th>\n",
       "      <th>amount</th>\n",
       "      <th>marketprice</th>\n",
       "      <th>convprice</th>\n",
       "      <th>firstdayprice</th>\n",
       "      <th>ipo_date</th>\n",
       "      <th>issue_date</th>\n",
       "      <th>ballot</th>\n",
       "      <th>return</th>\n",
       "      <th>perreturn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>128045</td>\n",
       "      <td>机电转债</td>\n",
       "      <td>2013</td>\n",
       "      <td>中航机电</td>\n",
       "      <td>72013</td>\n",
       "      <td>21.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>128044</td>\n",
       "      <td>岭南转债</td>\n",
       "      <td>2717</td>\n",
       "      <td>岭南股份</td>\n",
       "      <td>72717</td>\n",
       "      <td>6.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>123015</td>\n",
       "      <td>蓝盾转债</td>\n",
       "      <td>300297</td>\n",
       "      <td>蓝盾股份</td>\n",
       "      <td>370297</td>\n",
       "      <td>5.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.27%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>113517</td>\n",
       "      <td>曙光转债</td>\n",
       "      <td>603019</td>\n",
       "      <td>中科曙光</td>\n",
       "      <td>754019</td>\n",
       "      <td>11.20</td>\n",
       "      <td>108.50</td>\n",
       "      <td>51.28</td>\n",
       "      <td>106.36</td>\n",
       "      <td>2018-08-06</td>\n",
       "      <td>2018-08-23</td>\n",
       "      <td>1.93%</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>128043</td>\n",
       "      <td>东音转债</td>\n",
       "      <td>2793</td>\n",
       "      <td>东音股份</td>\n",
       "      <td>72793</td>\n",
       "      <td>2.81</td>\n",
       "      <td>94.82</td>\n",
       "      <td>13.47</td>\n",
       "      <td>96.32</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>46.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>113516</td>\n",
       "      <td>吴银转债</td>\n",
       "      <td>603323</td>\n",
       "      <td>吴江银行</td>\n",
       "      <td>754323</td>\n",
       "      <td>25.00</td>\n",
       "      <td>103.84</td>\n",
       "      <td>6.34</td>\n",
       "      <td>99.20</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>0.51%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>19.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>128042</td>\n",
       "      <td>凯中转债</td>\n",
       "      <td>2823</td>\n",
       "      <td>凯中精密</td>\n",
       "      <td>72823</td>\n",
       "      <td>4.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-30</td>\n",
       "      <td>2018-09-03</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>123014</td>\n",
       "      <td>凯发转债</td>\n",
       "      <td>300407</td>\n",
       "      <td>凯发电气</td>\n",
       "      <td>370407</td>\n",
       "      <td>3.50</td>\n",
       "      <td>93.18</td>\n",
       "      <td>8.15</td>\n",
       "      <td>91.15</td>\n",
       "      <td>2018-07-27</td>\n",
       "      <td>2018-08-21</td>\n",
       "      <td>0.45%</td>\n",
       "      <td>-0.04%</td>\n",
       "      <td>22.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>113515</td>\n",
       "      <td>高能转债</td>\n",
       "      <td>603588</td>\n",
       "      <td>高能环境</td>\n",
       "      <td>754588</td>\n",
       "      <td>8.40</td>\n",
       "      <td>99.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99.34</td>\n",
       "      <td>2018-07-26</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>0.34%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>29.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>123013</td>\n",
       "      <td>横河转债</td>\n",
       "      <td>300539</td>\n",
       "      <td>横河模具</td>\n",
       "      <td>370539</td>\n",
       "      <td>1.40</td>\n",
       "      <td>92.83</td>\n",
       "      <td>9.26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-26</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>0.15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>123012</td>\n",
       "      <td>万顺转债</td>\n",
       "      <td>300057</td>\n",
       "      <td>万顺股份</td>\n",
       "      <td>370057</td>\n",
       "      <td>9.50</td>\n",
       "      <td>91.89</td>\n",
       "      <td>6.47</td>\n",
       "      <td>91.92</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>2018-08-29</td>\n",
       "      <td>1.73%</td>\n",
       "      <td>-0.13%</td>\n",
       "      <td>5.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>113514</td>\n",
       "      <td>威帝转债</td>\n",
       "      <td>603023</td>\n",
       "      <td>威帝股份</td>\n",
       "      <td>754023</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.92</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>123011</td>\n",
       "      <td>德尔转债</td>\n",
       "      <td>300473</td>\n",
       "      <td>德尔股份</td>\n",
       "      <td>370473</td>\n",
       "      <td>5.65</td>\n",
       "      <td>98.30</td>\n",
       "      <td>35.26</td>\n",
       "      <td>96.34</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.33%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>30.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>128041</td>\n",
       "      <td>盛路转债</td>\n",
       "      <td>2446</td>\n",
       "      <td>盛路通信</td>\n",
       "      <td>72446</td>\n",
       "      <td>10.00</td>\n",
       "      <td>100.46</td>\n",
       "      <td>6.88</td>\n",
       "      <td>96.83</td>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.61%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>16.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>110045</td>\n",
       "      <td>海澜转债</td>\n",
       "      <td>600398</td>\n",
       "      <td>海澜之家</td>\n",
       "      <td>704398</td>\n",
       "      <td>30.00</td>\n",
       "      <td>99.20</td>\n",
       "      <td>12.40</td>\n",
       "      <td>100.80</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>113513</td>\n",
       "      <td>安井转债</td>\n",
       "      <td>603345</td>\n",
       "      <td>安井食品</td>\n",
       "      <td>754345</td>\n",
       "      <td>5.00</td>\n",
       "      <td>106.65</td>\n",
       "      <td>35.46</td>\n",
       "      <td>110.43</td>\n",
       "      <td>2018-07-12</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>113512</td>\n",
       "      <td>景旺转债</td>\n",
       "      <td>603228</td>\n",
       "      <td>景旺电子</td>\n",
       "      <td>754228</td>\n",
       "      <td>9.78</td>\n",
       "      <td>118.40</td>\n",
       "      <td>50.01</td>\n",
       "      <td>120.45</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>0.23%</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>123010</td>\n",
       "      <td>博世转债</td>\n",
       "      <td>300422</td>\n",
       "      <td>博世科</td>\n",
       "      <td>370422</td>\n",
       "      <td>4.30</td>\n",
       "      <td>95.00</td>\n",
       "      <td>14.30</td>\n",
       "      <td>97.36</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>0.36%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>27.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>127007</td>\n",
       "      <td>湖广转债</td>\n",
       "      <td>665</td>\n",
       "      <td>湖北广电</td>\n",
       "      <td>70665</td>\n",
       "      <td>17.34</td>\n",
       "      <td>93.78</td>\n",
       "      <td>10.16</td>\n",
       "      <td>93.16</td>\n",
       "      <td>2018-06-28</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>1.01%</td>\n",
       "      <td>-0.06%</td>\n",
       "      <td>987.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>110044</td>\n",
       "      <td>广电转债</td>\n",
       "      <td>600831</td>\n",
       "      <td>广电网络</td>\n",
       "      <td>733831</td>\n",
       "      <td>8.00</td>\n",
       "      <td>93.91</td>\n",
       "      <td>6.91</td>\n",
       "      <td>95.80</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>24.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>113511</td>\n",
       "      <td>千禾转债</td>\n",
       "      <td>603027</td>\n",
       "      <td>千禾味业</td>\n",
       "      <td>754027</td>\n",
       "      <td>3.56</td>\n",
       "      <td>93.52</td>\n",
       "      <td>25.86</td>\n",
       "      <td>98.87</td>\n",
       "      <td>2018-06-20</td>\n",
       "      <td>2018-07-10</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>70.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>113510</td>\n",
       "      <td>再升转债</td>\n",
       "      <td>603601</td>\n",
       "      <td>再升科技</td>\n",
       "      <td>754601</td>\n",
       "      <td>1.14</td>\n",
       "      <td>93.69</td>\n",
       "      <td>11.32</td>\n",
       "      <td>95.81</td>\n",
       "      <td>2018-06-19</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>0.06%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>158.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>128040</td>\n",
       "      <td>华通转债</td>\n",
       "      <td>2758</td>\n",
       "      <td>华通医药</td>\n",
       "      <td>72758</td>\n",
       "      <td>2.24</td>\n",
       "      <td>90.60</td>\n",
       "      <td>11.45</td>\n",
       "      <td>96.60</td>\n",
       "      <td>2018-06-14</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>232.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>128039</td>\n",
       "      <td>三力转债</td>\n",
       "      <td>2224</td>\n",
       "      <td>三力士</td>\n",
       "      <td>72224</td>\n",
       "      <td>6.20</td>\n",
       "      <td>98.62</td>\n",
       "      <td>7.38</td>\n",
       "      <td>89.50</td>\n",
       "      <td>2018-06-08</td>\n",
       "      <td>2018-06-29</td>\n",
       "      <td>0.13%</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>74.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>113509</td>\n",
       "      <td>新泉转债</td>\n",
       "      <td>603179</td>\n",
       "      <td>新泉股份</td>\n",
       "      <td>754179</td>\n",
       "      <td>4.50</td>\n",
       "      <td>99.14</td>\n",
       "      <td>25.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.03%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>326.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>113508</td>\n",
       "      <td>新凤转债</td>\n",
       "      <td>603225</td>\n",
       "      <td>新凤鸣</td>\n",
       "      <td>754225</td>\n",
       "      <td>21.53</td>\n",
       "      <td>103.31</td>\n",
       "      <td>23.74</td>\n",
       "      <td>99.52</td>\n",
       "      <td>2018-04-26</td>\n",
       "      <td>2018-05-16</td>\n",
       "      <td>0.23%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>42.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>113507</td>\n",
       "      <td>天马转债</td>\n",
       "      <td>603668</td>\n",
       "      <td>天马科技</td>\n",
       "      <td>754668</td>\n",
       "      <td>3.05</td>\n",
       "      <td>91.91</td>\n",
       "      <td>10.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-17</td>\n",
       "      <td>2018-05-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>113506</td>\n",
       "      <td>鼎信转债</td>\n",
       "      <td>603421</td>\n",
       "      <td>鼎信通讯</td>\n",
       "      <td>754421</td>\n",
       "      <td>6.00</td>\n",
       "      <td>95.35</td>\n",
       "      <td>21.65</td>\n",
       "      <td>106.16</td>\n",
       "      <td>2018-04-16</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>0.07%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>138.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>128038</td>\n",
       "      <td>利欧转债</td>\n",
       "      <td>2131</td>\n",
       "      <td>利欧股份</td>\n",
       "      <td>72131</td>\n",
       "      <td>21.98</td>\n",
       "      <td>87.50</td>\n",
       "      <td>2.75</td>\n",
       "      <td>97.80</td>\n",
       "      <td>2018-03-22</td>\n",
       "      <td>2018-04-19</td>\n",
       "      <td>0.27%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>37.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>128037</td>\n",
       "      <td>岩土转债</td>\n",
       "      <td>2542</td>\n",
       "      <td>中化岩土</td>\n",
       "      <td>72542</td>\n",
       "      <td>6.04</td>\n",
       "      <td>86.81</td>\n",
       "      <td>8.03</td>\n",
       "      <td>95.20</td>\n",
       "      <td>2018-03-15</td>\n",
       "      <td>2018-04-25</td>\n",
       "      <td>0.09%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>110.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>127006</td>\n",
       "      <td>敖东转债</td>\n",
       "      <td>623</td>\n",
       "      <td>吉林敖东</td>\n",
       "      <td>70623</td>\n",
       "      <td>24.13</td>\n",
       "      <td>98.64</td>\n",
       "      <td>20.82</td>\n",
       "      <td>105.39</td>\n",
       "      <td>2018-03-13</td>\n",
       "      <td>2018-05-11</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>80.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>31</td>\n",
       "      <td>127005</td>\n",
       "      <td>长证转债</td>\n",
       "      <td>783</td>\n",
       "      <td>长江证券</td>\n",
       "      <td>70783</td>\n",
       "      <td>50.00</td>\n",
       "      <td>96.15</td>\n",
       "      <td>7.45</td>\n",
       "      <td>106.90</td>\n",
       "      <td>2018-03-12</td>\n",
       "      <td>2018-04-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>32</td>\n",
       "      <td>128036</td>\n",
       "      <td>金农转债</td>\n",
       "      <td>2548</td>\n",
       "      <td>金新农</td>\n",
       "      <td>72548</td>\n",
       "      <td>6.50</td>\n",
       "      <td>88.03</td>\n",
       "      <td>9.62</td>\n",
       "      <td>100.01</td>\n",
       "      <td>2018-03-09</td>\n",
       "      <td>2018-04-02</td>\n",
       "      <td>0.05%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>123009</td>\n",
       "      <td>星源转债</td>\n",
       "      <td>300568</td>\n",
       "      <td>星源材质</td>\n",
       "      <td>370568</td>\n",
       "      <td>4.80</td>\n",
       "      <td>116.90</td>\n",
       "      <td>27.69</td>\n",
       "      <td>119.35</td>\n",
       "      <td>2018-03-07</td>\n",
       "      <td>2018-04-10</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>244.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>113505</td>\n",
       "      <td>杭电转债</td>\n",
       "      <td>603618</td>\n",
       "      <td>杭电股份</td>\n",
       "      <td>754618</td>\n",
       "      <td>7.80</td>\n",
       "      <td>92.89</td>\n",
       "      <td>7.29</td>\n",
       "      <td>100.87</td>\n",
       "      <td>2018-03-06</td>\n",
       "      <td>2018-03-27</td>\n",
       "      <td>0.08%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>118.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>113504</td>\n",
       "      <td>艾华转债</td>\n",
       "      <td>603989</td>\n",
       "      <td>艾华集团</td>\n",
       "      <td>754989</td>\n",
       "      <td>6.91</td>\n",
       "      <td>109.01</td>\n",
       "      <td>36.59</td>\n",
       "      <td>108.55</td>\n",
       "      <td>2018-03-02</td>\n",
       "      <td>2018-03-23</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>457.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>113019</td>\n",
       "      <td>玲珑转债</td>\n",
       "      <td>601966</td>\n",
       "      <td>玲珑轮胎</td>\n",
       "      <td>783966</td>\n",
       "      <td>20.00</td>\n",
       "      <td>103.80</td>\n",
       "      <td>18.84</td>\n",
       "      <td>104.97</td>\n",
       "      <td>2018-03-01</td>\n",
       "      <td>2018-03-22</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>47.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>128035</td>\n",
       "      <td>大族转债</td>\n",
       "      <td>2008</td>\n",
       "      <td>大族激光</td>\n",
       "      <td>72008</td>\n",
       "      <td>23.00</td>\n",
       "      <td>107.97</td>\n",
       "      <td>52.50</td>\n",
       "      <td>116.34</td>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>2018-03-05</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>51.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>132015</td>\n",
       "      <td>18中油EB</td>\n",
       "      <td>601857</td>\n",
       "      <td>中国石油</td>\n",
       "      <td>759000</td>\n",
       "      <td>200.00</td>\n",
       "      <td>98.43</td>\n",
       "      <td>9.38</td>\n",
       "      <td>98.68</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>-0.64%</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>123008</td>\n",
       "      <td>康泰转债</td>\n",
       "      <td>300601</td>\n",
       "      <td>康泰生物</td>\n",
       "      <td>370601</td>\n",
       "      <td>3.56</td>\n",
       "      <td>149.88</td>\n",
       "      <td>31.23</td>\n",
       "      <td>119.98</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>2018-03-19</td>\n",
       "      <td>0.03%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>387.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>110043</td>\n",
       "      <td>无锡转债</td>\n",
       "      <td>600908</td>\n",
       "      <td>无锡银行</td>\n",
       "      <td>733908</td>\n",
       "      <td>30.00</td>\n",
       "      <td>97.95</td>\n",
       "      <td>6.85</td>\n",
       "      <td>97.43</td>\n",
       "      <td>2018-01-30</td>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>0.19%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>53.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>128034</td>\n",
       "      <td>江银转债</td>\n",
       "      <td>2807</td>\n",
       "      <td>江阴银行</td>\n",
       "      <td>72807</td>\n",
       "      <td>20.00</td>\n",
       "      <td>100.96</td>\n",
       "      <td>6.92</td>\n",
       "      <td>97.76</td>\n",
       "      <td>2018-01-26</td>\n",
       "      <td>2018-02-14</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>113018</td>\n",
       "      <td>常熟转债</td>\n",
       "      <td>601128</td>\n",
       "      <td>常熟银行</td>\n",
       "      <td>783128</td>\n",
       "      <td>30.00</td>\n",
       "      <td>107.87</td>\n",
       "      <td>7.61</td>\n",
       "      <td>107.91</td>\n",
       "      <td>2018-01-19</td>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>0.19%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>51.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>43</td>\n",
       "      <td>123007</td>\n",
       "      <td>道氏转债</td>\n",
       "      <td>300409</td>\n",
       "      <td>道氏技术</td>\n",
       "      <td>370409</td>\n",
       "      <td>4.80</td>\n",
       "      <td>95.70</td>\n",
       "      <td>24.99</td>\n",
       "      <td>118.00</td>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>2018-01-26</td>\n",
       "      <td>0.07%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>139.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>113017</td>\n",
       "      <td>吉视转债</td>\n",
       "      <td>601929</td>\n",
       "      <td>吉视传媒</td>\n",
       "      <td>783929</td>\n",
       "      <td>15.60</td>\n",
       "      <td>90.85</td>\n",
       "      <td>2.98</td>\n",
       "      <td>98.08</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>0.40%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>45</td>\n",
       "      <td>128033</td>\n",
       "      <td>迪龙转债</td>\n",
       "      <td>2658</td>\n",
       "      <td>雪迪龙</td>\n",
       "      <td>72658</td>\n",
       "      <td>5.20</td>\n",
       "      <td>95.67</td>\n",
       "      <td>13.28</td>\n",
       "      <td>104.00</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>2018-01-29</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>258.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>110042</td>\n",
       "      <td>航电转债</td>\n",
       "      <td>600372</td>\n",
       "      <td>中航电子</td>\n",
       "      <td>733372</td>\n",
       "      <td>24.00</td>\n",
       "      <td>107.00</td>\n",
       "      <td>14.29</td>\n",
       "      <td>101.76</td>\n",
       "      <td>2017-12-25</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>50.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>47</td>\n",
       "      <td>128032</td>\n",
       "      <td>双环转债</td>\n",
       "      <td>2472</td>\n",
       "      <td>双环传动</td>\n",
       "      <td>72472</td>\n",
       "      <td>10.00</td>\n",
       "      <td>95.60</td>\n",
       "      <td>9.99</td>\n",
       "      <td>104.75</td>\n",
       "      <td>2017-12-25</td>\n",
       "      <td>2018-01-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>110041</td>\n",
       "      <td>蒙电转债</td>\n",
       "      <td>600863</td>\n",
       "      <td>内蒙华电</td>\n",
       "      <td>733863</td>\n",
       "      <td>18.75</td>\n",
       "      <td>98.18</td>\n",
       "      <td>2.95</td>\n",
       "      <td>104.18</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>2018-01-09</td>\n",
       "      <td>0.27%</td>\n",
       "      <td>0.01%</td>\n",
       "      <td>37.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>49</td>\n",
       "      <td>128029</td>\n",
       "      <td>太阳转债</td>\n",
       "      <td>2078</td>\n",
       "      <td>太阳纸业</td>\n",
       "      <td>72078</td>\n",
       "      <td>12.00</td>\n",
       "      <td>118.46</td>\n",
       "      <td>8.85</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>2018-01-16</td>\n",
       "      <td>0.04%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>232.16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0   bcode   bname   scode sname   xcode  amount  marketprice  \\\n",
       "0            0  128045    机电转债    2013  中航机电   72013   21.00          NaN   \n",
       "1            1  128044    岭南转债    2717  岭南股份   72717    6.60          NaN   \n",
       "2            2  123015    蓝盾转债  300297  蓝盾股份  370297    5.38          NaN   \n",
       "3            3  113517    曙光转债  603019  中科曙光  754019   11.20       108.50   \n",
       "4            4  128043    东音转债    2793  东音股份   72793    2.81        94.82   \n",
       "5            5  113516    吴银转债  603323  吴江银行  754323   25.00       103.84   \n",
       "6            6  128042    凯中转债    2823  凯中精密   72823    4.16          NaN   \n",
       "7            7  123014    凯发转债  300407  凯发电气  370407    3.50        93.18   \n",
       "8            8  113515    高能转债  603588  高能环境  754588    8.40        99.99   \n",
       "9            9  123013    横河转债  300539  横河模具  370539    1.40        92.83   \n",
       "10          10  123012    万顺转债  300057  万顺股份  370057    9.50        91.89   \n",
       "11          11  113514    威帝转债  603023  威帝股份  754023    2.00          NaN   \n",
       "12          12  123011    德尔转债  300473  德尔股份  370473    5.65        98.30   \n",
       "13          13  128041    盛路转债    2446  盛路通信   72446   10.00       100.46   \n",
       "14          14  110045    海澜转债  600398  海澜之家  704398   30.00        99.20   \n",
       "15          15  113513    安井转债  603345  安井食品  754345    5.00       106.65   \n",
       "16          16  113512    景旺转债  603228  景旺电子  754228    9.78       118.40   \n",
       "17          17  123010    博世转债  300422   博世科  370422    4.30        95.00   \n",
       "18          18  127007    湖广转债     665  湖北广电   70665   17.34        93.78   \n",
       "19          19  110044    广电转债  600831  广电网络  733831    8.00        93.91   \n",
       "20          20  113511    千禾转债  603027  千禾味业  754027    3.56        93.52   \n",
       "21          21  113510    再升转债  603601  再升科技  754601    1.14        93.69   \n",
       "22          22  128040    华通转债    2758  华通医药   72758    2.24        90.60   \n",
       "23          23  128039    三力转债    2224   三力士   72224    6.20        98.62   \n",
       "24          24  113509    新泉转债  603179  新泉股份  754179    4.50        99.14   \n",
       "25          25  113508    新凤转债  603225   新凤鸣  754225   21.53       103.31   \n",
       "26          26  113507    天马转债  603668  天马科技  754668    3.05        91.91   \n",
       "27          27  113506    鼎信转债  603421  鼎信通讯  754421    6.00        95.35   \n",
       "28          28  128038    利欧转债    2131  利欧股份   72131   21.98        87.50   \n",
       "29          29  128037    岩土转债    2542  中化岩土   72542    6.04        86.81   \n",
       "30          30  127006    敖东转债     623  吉林敖东   70623   24.13        98.64   \n",
       "31          31  127005    长证转债     783  长江证券   70783   50.00        96.15   \n",
       "32          32  128036    金农转债    2548   金新农   72548    6.50        88.03   \n",
       "33          33  123009    星源转债  300568  星源材质  370568    4.80       116.90   \n",
       "34          34  113505    杭电转债  603618  杭电股份  754618    7.80        92.89   \n",
       "35          35  113504    艾华转债  603989  艾华集团  754989    6.91       109.01   \n",
       "36          36  113019    玲珑转债  601966  玲珑轮胎  783966   20.00       103.80   \n",
       "37          37  128035    大族转债    2008  大族激光   72008   23.00       107.97   \n",
       "38          38  132015  18中油EB  601857  中国石油  759000  200.00        98.43   \n",
       "39          39  123008    康泰转债  300601  康泰生物  370601    3.56       149.88   \n",
       "40          40  110043    无锡转债  600908  无锡银行  733908   30.00        97.95   \n",
       "41          41  128034    江银转债    2807  江阴银行   72807   20.00       100.96   \n",
       "42          42  113018    常熟转债  601128  常熟银行  783128   30.00       107.87   \n",
       "43          43  123007    道氏转债  300409  道氏技术  370409    4.80        95.70   \n",
       "44          44  113017    吉视转债  601929  吉视传媒  783929   15.60        90.85   \n",
       "45          45  128033    迪龙转债    2658   雪迪龙   72658    5.20        95.67   \n",
       "46          46  110042    航电转债  600372  中航电子  733372   24.00       107.00   \n",
       "47          47  128032    双环转债    2472  双环传动   72472   10.00        95.60   \n",
       "48          48  110041    蒙电转债  600863  内蒙华电  733863   18.75        98.18   \n",
       "49          49  128029    太阳转债    2078  太阳纸业   72078   12.00       118.46   \n",
       "\n",
       "    convprice  firstdayprice    ipo_date  issue_date  ballot  return  \\\n",
       "0        7.66            NaN  2018-08-27         NaN   0.12%     NaN   \n",
       "1       10.70            NaN  2018-08-14         NaN     NaN     NaN   \n",
       "2        7.89            NaN  2018-08-13         NaN   1.27%     NaN   \n",
       "3       51.28         106.36  2018-08-06  2018-08-23   1.93%   0.02%   \n",
       "4       13.47          96.32  2018-08-02  2018-08-27   0.21%  -0.01%   \n",
       "5        6.34          99.20  2018-08-02  2018-08-20   0.51%  -0.01%   \n",
       "6       13.25            NaN  2018-07-30  2018-09-03   0.20%     NaN   \n",
       "7        8.15          91.15  2018-07-27  2018-08-21   0.45%  -0.04%   \n",
       "8         NaN          99.34  2018-07-26  2018-08-27   0.34%  -0.01%   \n",
       "9        9.26            NaN  2018-07-26  2018-08-20   0.15%     NaN   \n",
       "10       6.47          91.92  2018-07-20  2018-08-29   1.73%  -0.13%   \n",
       "11       5.92            NaN  2018-07-20  2018-08-13   0.28%     NaN   \n",
       "12      35.26          96.34  2018-07-18  2018-08-14   0.33%  -0.01%   \n",
       "13       6.88          96.83  2018-07-17  2018-08-14   0.61%  -0.01%   \n",
       "14      12.40         100.80  2018-07-13  2018-07-31     NaN     NaN   \n",
       "15      35.46         110.43  2018-07-12  2018-07-31     NaN     NaN   \n",
       "16      50.01         120.45  2018-07-06  2018-07-24   0.23%   0.04%   \n",
       "17      14.30          97.36  2018-07-05  2018-08-14   0.36%   0.00%   \n",
       "18      10.16          93.16  2018-06-28  2018-08-01   1.01%  -0.06%   \n",
       "19       6.91          95.80  2018-06-27  2018-07-24   0.41%  -0.02%   \n",
       "20      25.86          98.87  2018-06-20  2018-07-10   0.14%   0.00%   \n",
       "21      11.32          95.81  2018-06-19  2018-07-13   0.06%   0.00%   \n",
       "22      11.45          96.60  2018-06-14  2018-07-13   0.04%   0.00%   \n",
       "23       7.38          89.50  2018-06-08  2018-06-29   0.13%  -0.01%   \n",
       "24      25.34            NaN  2018-06-04         NaN   0.03%     NaN   \n",
       "25      23.74          99.52  2018-04-26  2018-05-16   0.23%   0.00%   \n",
       "26      10.98            NaN  2018-04-17  2018-05-07     NaN     NaN   \n",
       "27      21.65         106.16  2018-04-16  2018-05-14   0.07%   0.01%   \n",
       "28       2.75          97.80  2018-03-22  2018-04-19   0.27%   0.00%   \n",
       "29       8.03          95.20  2018-03-15  2018-04-25   0.09%   0.00%   \n",
       "30      20.82         105.39  2018-03-13  2018-05-11   0.12%   0.01%   \n",
       "31       7.45         106.90  2018-03-12  2018-04-11     NaN     NaN   \n",
       "32       9.62         100.01  2018-03-09  2018-04-02   0.05%   0.00%   \n",
       "33      27.69         119.35  2018-03-07  2018-04-10   0.04%   0.01%   \n",
       "34       7.29         100.87  2018-03-06  2018-03-27   0.08%   0.00%   \n",
       "35      36.59         108.55  2018-03-02  2018-03-23   0.02%   0.00%   \n",
       "36      18.84         104.97  2018-03-01  2018-03-22   0.21%   0.01%   \n",
       "37      52.50         116.34  2018-02-06  2018-03-05   0.20%   0.02%   \n",
       "38       9.38          98.68  2018-02-01  2018-02-28  30.00%  -0.64%   \n",
       "39      31.23         119.98  2018-02-01  2018-03-19   0.03%   0.01%   \n",
       "40       6.85          97.43  2018-01-30  2018-03-14   0.19%   0.00%   \n",
       "41       6.92          97.76  2018-01-26  2018-02-14   0.14%   0.00%   \n",
       "42       7.61         107.91  2018-01-19  2018-02-06   0.19%   0.01%   \n",
       "43      24.99         118.00  2017-12-28  2018-01-26   0.07%   0.01%   \n",
       "44       2.98          98.08  2017-12-27  2018-01-15   0.40%   0.01%   \n",
       "45      13.28         104.00  2017-12-27  2018-01-29   0.04%   0.00%   \n",
       "46      14.29         101.76  2017-12-25  2018-01-15   0.20%   0.01%   \n",
       "47       9.99         104.75  2017-12-25  2018-01-25     NaN     NaN   \n",
       "48       2.95         104.18  2017-12-22  2018-01-09   0.27%   0.01%   \n",
       "49       8.85            NaN  2017-12-22  2018-01-16   0.04%     NaN   \n",
       "\n",
       "    perreturn  \n",
       "0       83.70  \n",
       "1         NaN  \n",
       "2        7.86  \n",
       "3        0.00  \n",
       "4       46.91  \n",
       "5       19.66  \n",
       "6       50.47  \n",
       "7       22.01  \n",
       "8       29.71  \n",
       "9       66.77  \n",
       "10       5.80  \n",
       "11      35.32  \n",
       "12      30.74  \n",
       "13      16.43  \n",
       "14        NaN  \n",
       "15        NaN  \n",
       "16       4.35  \n",
       "17      27.72  \n",
       "18     987.37  \n",
       "19      24.16  \n",
       "20      70.06  \n",
       "21     158.60  \n",
       "22     232.06  \n",
       "23      74.95  \n",
       "24     326.41  \n",
       "25      42.81  \n",
       "26        NaN  \n",
       "27     138.80  \n",
       "28      37.01  \n",
       "29     110.95  \n",
       "30      80.80  \n",
       "31        NaN  \n",
       "32        NaN  \n",
       "33     244.49  \n",
       "34     118.57  \n",
       "35     457.45  \n",
       "36      47.21  \n",
       "37      51.07  \n",
       "38       3.05  \n",
       "39     387.05  \n",
       "40      53.15  \n",
       "41      72.00  \n",
       "42      51.99  \n",
       "43     139.22  \n",
       "44       0.10  \n",
       "45     258.40  \n",
       "46      50.80  \n",
       "47        NaN  \n",
       "48      37.51  \n",
       "49     232.16  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bondbasic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>display_name</th>\n",
       "      <th>name</th>\n",
       "      <th>start_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001.XSHE</td>\n",
       "      <td>平安银行</td>\n",
       "      <td>PAYH</td>\n",
       "      <td>1991/4/3</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000002.XSHE</td>\n",
       "      <td>万科Ａ</td>\n",
       "      <td>WKA</td>\n",
       "      <td>1991/1/29</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000004.XSHE</td>\n",
       "      <td>国农科技</td>\n",
       "      <td>GNKJ</td>\n",
       "      <td>1990/12/1</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000005.XSHE</td>\n",
       "      <td>世纪星源</td>\n",
       "      <td>SJXY</td>\n",
       "      <td>1990/12/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000006.XSHE</td>\n",
       "      <td>深振业Ａ</td>\n",
       "      <td>SZYA</td>\n",
       "      <td>1992/4/27</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          code display_name  name  start_date  end_date   type\n",
       "0  000001.XSHE         平安银行  PAYH    1991/4/3  2200/1/1  stock\n",
       "1  000002.XSHE          万科Ａ   WKA   1991/1/29  2200/1/1  stock\n",
       "2  000004.XSHE         国农科技  GNKJ   1990/12/1  2200/1/1  stock\n",
       "3  000005.XSHE         世纪星源  SJXY  1990/12/10  2200/1/1  stock\n",
       "4  000006.XSHE         深振业Ａ  SZYA   1992/4/27  2200/1/1  stock"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stockinfo.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
